/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 vote133 views1 answer
Oracle c# multiple update sql
SQL
2 votes175 views2 answers
Mysql date range
SQL
4 votes129 views1 answer
Mac install mysql
SQL
2 votes112 views1 answer
Mysql list users on ubuntu
SQL
0 vote137 views1 answer
Sql convert float to string
SQL
0 vote124 views5 answers
Linq cheat sheet
SQL
8 votes141 views1 answer
Oracle search stored procedures for text
SQL
3 votes127 views1 answer
Create a table with an id in mysql
SQL
0 vote132 views1 answer
Select row with latest date mysql
SQL
0 vote123 views1 answer
Sum sqlserver
SQL

Share