easy way to query without putting everything in quotation marks

Question

How do I query in MySql without putting all inserts in quotations? (I have a big list and it would take to much time to quote and unquote every word)

Example:

SELECT *
FROM names 
WHERE names.first IN ("joe", "tom", "vincent")

Is the list in a table? If so, you could do something like: WHERE names.first IN (SELECT fname FROM wanted_names_table) — Ben, Aug 01 '18 at 12:10
see: https://stackoverflow.com/questions/37145203/put-quotes-around-each-word-in-comma-separated-sql-string — DNKROZ, Aug 01 '18 at 12:20

score 1 · Accepted Answer · answered Aug 01 '18 at 12:23

1

Since you said the list is comma separated, simply use the 'find and replace' feature to find all commas and replace them with ","

The result should be joe","tom","vincent"," which you can simply copy into mysql. All you then have to do is edit the start and end of the string

answered Aug 01 '18 at 12:23

daje

This does sort my problem. However, I was wondering if there is a mysql solution! – nemja Aug 01 '18 at 12:25
1

Use replace function in MYSQL. – Ankit Bajpai Aug 01 '18 at 12:41

1 Answers1