RenĂ© H4 Posted October 3, 2019 Share Posted October 3, 2019 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';  Link to comment Share on other sites More sharing options...
Dan Cole Posted October 3, 2019 Share Posted October 3, 2019 I would add a "%" to the beginning and end of what you're searching for....ie. '%boekje.jpg%' Dan Need help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix) here. Link to comment Share on other sites More sharing options...
RenĂ© H4 Posted October 3, 2019 Author Share Posted October 3, 2019 Thanks Dan, this probably would have been my next question đŸ™‚  Link to comment Share on other sites More sharing options...
René H4 Posted October 3, 2019 Author Share Posted October 3, 2019 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.....  Link to comment Share on other sites More sharing options...
Dan Cole Posted October 3, 2019 Share Posted October 3, 2019 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 Need help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix) here. Link to comment Share on other sites More sharing options...
René H4 Posted October 3, 2019 Author Share Posted October 3, 2019 Thanks Dan I found that. Works well.... Also ready for pasting to Excel, not only Notepad. Link to comment Share on other sites More sharing options...
♥ecartz Posted October 4, 2019 Share Posted October 4, 2019 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 Always back up before making changes. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.