database query SQL

[René H4]

Well, I don't know databases but I am anqiuos to learn..... 🙂

I need to find in which products the string "boekje.jpg" is used in the products description.

Is this the correct string to enter in MyPHPAdmin:

SELECT * FROM products_description WHERE products_description LIKE 'boekje.jpg';

 

[Dan Cole]

I would add a "%" to the beginning and end of what you're searching for....ie.

'%boekje.jpg%'

Dan

[René H4]

Thanks Dan, this probably would have been my next question 🙂

 

[René H4]

Would there be an aesy way to output the results to a .txt file?

 

Edit: I now see I can do a copy to the clipboard.....

 

[Dan Cole]

I haven't tried it but at the bottom of the search results, there is an export button...at least on the version of MyPHPAdmin  that I'm using.

Dan

[René H4]

Thanks Dan I found that. Works well.... Also ready for pasting to Excel, not only Notepad.

[♥ecartz]

If you are looking for an exact string, you can just use equals. 

SELECT * FROM products_description WHERE products_description = 'boekje.jpg';

You only need to use LIKE if you are looking for a partial string.  E.g.

SELECT * FROM products_description WHERE products_description LIKE '_oekje%.jpg';

Will match any string that has any first character and then oekje followed by any characters and ending with .jpg .  I would not expect that you'd normally want to put a wildcard at the end of .jpg in an image search.  I would think that something like %boekje%.% would be more common (any image with boekje in it, regardless of extension). 

Documentation:  https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html

Regular expressions:  https://dev.mysql.com/doc/refman/8.0/en/regexp.html