thesuhu

MySQL Query

Apr 18th, 2022 (edited)
772
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # cari data yg kolom mengandung huruf
  2. SELECT * FROM <nama tabel> WHERE <nama kolom> REGEXP '[[:alpha:]]+';
  3.  
  4. # mendapatkan tanggal 1 bulan yang lalu
  5. SELECT DATE_SUB(NOW(), INTERVAL 1 MONTH);
RAW Paste Data Copied