this SELECT query didn't work

Leafgreen · #1 (**permalink**) 01-05-12, 01:00

This SELECT query didn't work.

Code:

SELECT * FROM xcart_product_options_js
   WHERE javascript_code LIKE 'pull-down menu just above the "Take it" button'
   LIMIT 0 , 100

No records were found, even though I know those values exist. Do I need to escape the quote characters or something like that? Thank you

r937 · #2 (**permalink**) 01-05-12, 04:53

you didn't use any LIKE wildcard characters, so the query is looking for a row with an exact match for that column value

Leafgreen · #3 (**permalink**) 01-05-12, 05:03

Code:

SELECT * FROM xcart_product_options_js
   WHERE javascript_code LIKE '%pull-down menu just above the "Take it" button%'
   LIMIT 0 , 100

Ok, then is this correct? But it still does not find the records...

it-iss.com · #4 (**permalink**) 01-05-12, 05:09

You do not need to escape the double quotes so it does look alright. If this does not work then I would look more closely at my data in the database.

Leafgreen · #5 (**permalink**) 01-05-12, 11:04

Quote:

Originally Posted by r937

you didn't use any LIKE wildcard characters, so the query is looking for a row with an exact match for that column value

Yes, that is probably the issue, as I am not looking for an exact match...just a match of that string within the entire column value. How do I add wildcard characters to the query, please?

r937 · #6 (**permalink**) 01-05-12, 11:11

Quote:

Originally Posted by Leafgreen

Yes How do I add wildcard characters to the query, please?

you did this already, in post #3 -- the percent signs

as ronan said, look at your data more closely

Leafgreen · #7 (**permalink**) 01-11-12, 04:45

Nope. It's the query syntax. If I execute

Code:

SELECT *
FROM `xcart_product_options_js`
WHERE `javascript_code` LIKE '%pull-down menu just above the%'
LIMIT 0 , 30

then I get a found set. if I execute

Code:

SELECT *
FROM `xcart_product_options_js`
WHERE `javascript_code` LIKE '%pull-down menu just above the ''Take it'' button%'
LIMIT 0 , 30

then I get no results. The problem is the quotes in ''Take it''. I've also tried " character. BTW, if I try searching just Take it then I also do not get any results. The '' messes things up. Please help. Thank you.

r937 · #8 (**permalink**) 01-11-12, 06:10

Quote:

Originally Posted by Leafgreen

Please help. Thank you.

do you know how to dump a table?

please dump the table, then copy both the CREATE TABLE statement, as well as the INSERT statement for at least one row which contains the data that you're trying to return with this query

Internet Services

Web Development

Digital Marketing

Consumer Tech