Querying using single quotes

[vbredpgr]

I'm used to running queries on Transact-SQL. I'm sure there's something wrong with the Where clause in the following statement:

select e_search from tbl_memory where show = 'Y'

I'm using this with PHP but I still get the error even when I'm running this in phpMyAdmin.

Here's my error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show = 'Y'

Thanks.

 

[Sleidia]

Should be :

SELECT e_search FROM tbl_memory WHERE show [b]LIKE[/b] 'Y'

 

[vbredpgr]

I found the solution. When I use the tick symbol( ` ) around the fields and table names it worked:

SELECT `e_search` FROM `tbl_memory` WHERE `show` = 'Y'

Thanks for your input

 

[vacunita]

The reason for that, is that Show is a reserved word in MYSQL. so you need the back ticks to differentiate it.



----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[guelphdad]

better still, rename the column.