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