[SOLVED] qry getting broken, I think

[scottybwoy]

Hi putting this qry in MySQL admin :

SELECT FROM products_description
WHERE products_id =279
AND language_id =1
AND products_description LIKE '%Product Information is not available for this product yet. Sorry for any inconvenience, this should be updated shortly.'

Returns this 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 'FROM products_description WHERE products_id = 279 AND language_id = 1 AND produc' at line 1 

 

Does that mean it's only processing that part of the query or there's something wrong with the syntax I can't spot?

[elflacodepr]

I believe you are not telling MySQL what column to select from 'products_description'

 

The query must be like: (you can use an asterisk or other column name)

SELECT * FROM products_description
WHERE products_id =279
AND language_id =1
AND products_description LIKE '%Product Information is not available for this product yet. Sorry for any inconvenience, this should be updated shortly.'

[scottybwoy]

lol,

 

How simply stupid I was, thanks