Fibonacci Fibonacci - 1 year ago 61
MySQL Question

PhpMyAdmin search returns row but Sql returns null

when I search in the PhpMyAdmin an email of the style of



It returns a row. But whenever I search it using an sql sentence, either from php or either executing the query from PhpMyAdmin

The query I'm using is

SELECT * FROM tblMyTable WHERE field LIKE ''

Can it be because of the @?


Answer Source

Got it to work with

SELECT * FROM  `tblTable` WHERE  `field` LIKE  ''

For some reason without the ' in the table name and field name wasn't working

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download