/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

16 votes261 views4 answers
Find duplicates mysql
SQL
0 vote157 views1 answer
Expose db in virtualbox
SQL
14 votes195 views3 answers
Alter foreign key
SQL
0 vote221 views1 answer
Sql select min row
SQL
0 vote203 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote226 views1 answer
Mysql conf.d exampel
SQL
0 vote190 views1 answer
Order by ip address sql
SQL
2 votes188 views1 answer
Oracle cpu per session
SQL
1 vote192 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote191 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL

Share