/SQL/Mysql SELECT

Mysql SELECT

How to select all attributes from a row if there is a certain string in it MySQL

SELECT column1, column2,...
FROM table_name
WHERE first_name = 'John' AND sales_in_year <= 50

1

Mysql SELECT

SELECT 
  `nachname` , `vorname` 
FROM testadressen
WHERE vorname = 'Fischer'

0

Source: php-kurs.com

Similar codes

0 vote378 views1 answer
Oracle list user locked
SQL
0 vote340 views1 answer
Less than and between in sql query
SQL
0 vote344 views1 answer
How to get data from 2 database
SQL
0 vote324 views1 answer
Order by number of character in sql
SQL
3 votes337 views2 answers
Monthname sql
SQL
0 vote358 views1 answer
Show mysql account privilleges
SQL
0 vote337 views1 answer
User defined variables in sql
SQL
0 vote321 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
0 vote343 views1 answer
How to add timestamp column in mysql
SQL
0 vote366 views1 answer
How to find the most occuring in SQL
SQL

Share