MySQL select文の要約

#   
SELECT cpu FROM laptop

#   
SELECT DISTINCT cpu FROM laptop

#      
SELECT id FROM laptop
LIMIT 5

#   22      
SELECT id FROM laptop
LIMIT 21, 5

#       ，    desc
SELECT `memory` FROM laptop
ORDER BY `memory` DESC 

#     where    
SELECT * FROM laptop
WHERE laptop.disk='512GB'

SELECT * FROM laptop
WHERE laptop.disk<>'512GB'

SELECT * FROM laptop
WHERE laptop.disk!='512GB'

SELECT * FROM laptop
WHERE laptop.memory>8

SELECT * FROM laptop
WHERE laptop.memory>=8

SELECT * FROM laptop
WHERE laptop.memory<16

SELECT * FROM laptop
WHERE laptop.memory<8

#     ，  and or not  
SELECT * FROM laptop
WHERE laptop.memory BETWEEN 8 AND 16

#    %
SELECT * FROM laptop
WHERE laptop.cpu LIKE '%i%'

#    _
SELECT * FROM laptop
WHERE laptop.cpu LIKE '_ayzen'

#      
#            
SELECT cpu FROM laptop
WHERE cpu REGEXP 'i'

#               
SELECT laptop.disk FROM laptop
WHERE laptop.disk REGEXP '512|1T'

#       
SELECT laptop.disk FROM laptop
WHERE laptop.disk REGEXP '[12]T'

#        
SELECT cpu FROM laptop
WHERE cpu REGEXP '[^i57]'

#     
SELECT id FROM laptop
WHERE id REGEXP '[0-9]'

#      
SELECT CONCAT(id,'(',cpu,')') AS cpulist FROM laptop

#       

# left             ，      
SELECT LEFT(cpu, 1) FROM laptop
SELECT RIGHT(cpu, 10) FROM laptop

#            
SELECT LENGTH(id) FROM laptop

#          ，     0
SELECT LOCATE("a", cpu) FROM laptop

#         ，     （   2）   
SELECT LOCATE(1, id, 2) FROM laptop 

#              （     ） 
SELECT SUBSTRING(`disk`, 2) FROM laptop
SELECT SUBSTRING(`disk` FROM 2) FROM laptop

#         2   
SELECT SUBSTRING(`disk`, 2, 2) FROM laptop
SELECT SUBSTRING(`disk` FROM 2 FOR 2) FROM laptop

#       
SELECT cpu FROM laptop
WHERE SOUNDEX(cpu)=SOUNDEX("raisen")

# lower upper   ，   ，trim rtrim ltrim    ，   

#      
SELECT cpu, COUNT(id) FROM laptop
GROUP BY cpu
HAVING cpu <> "rayzen"

#    
SELECT cpu FROM laptop
WHERE `memory`=16 AND graphics NOT IN (SELECT graphics FROM laptop WHERE graphics="uhd")

#   
SELECT l1.cpu 
FROM laptop AS l1, laptop AS l2
WHERE l1.id=l2.id AND l1.memory=16 AND l1.graphics="vega"

#   
SELECT id FROM laptop
WHERE id<11
UNION
SELECT id FROM laptop
WHERE id>20