/SQL/Mysql select where field is a value

Mysql select where field is a value

SELECT *
FROM myTable
WHERE myColumn = 'resultA' 
   OR myColumn = 'resultB' 
   OR myColumn = 'resultC';

-- Alternatively,

SELECT *
FROM myTable
WHERE myColumn IN ('resultA', 'resultB', 'resultC');

Source: stackoverflow.com

Similar codes

0 vote269 views1 answer
Unique element in sql
SQL
22 votes279 views3 answers
SQL CHEATSHEET
SQL
0 vote267 views1 answer
Mysql count by month
SQL
0 vote283 views1 answer
Flexible search query delete table
SQL
12 votes279 views1 answer
Script to add new column in table sql
SQL
0 vote286 views1 answer
Oarcale list objects
SQL
0 vote259 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
2 votes266 views6 answers
In in sql
SQL
0 vote314 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
5 votes263 views1 answer
Mysql change primary key
SQL