0

I would like to search state_Abbreviation like TX. below is the query I tried so far:

SELECT *
FROM `usa_address`
WHERE   ' One American Center, Suite 3000 600 Congress Avenue Austin , TX  78701'
             LIKE CONCAT('%',usa_address.city,'%')
    AND ' One American Center, Suite 3000 600 Congress Avenue Austin , TX  78701  '
             LIKE CONCAT('%',UPPER(usa_address.state_Abbreviation),'%')

enter image description here

subhasadiq
  • 1
  • 3
  • It doesn't look good when you're asking for help but can't spend a couple of minutes putting together a readable question. – shmosel Jan 16 '17 at 11:08
  • 1
    Possible duplicate of [How do you force mysql LIKE to be case sensitive?](http://stackoverflow.com/questions/14007450/how-do-you-force-mysql-like-to-be-case-sensitive) – shmosel Jan 16 '17 at 11:10

0 Answers0