Recent questions tagged sql

1 answer 52 views

How to fetch rows where a field value is less than or equal to 15 characters in MySQL with SQL

asked Jul 15 by avibootz

1 answer 71 views

How to replace part of a string in MySQL with SQL

asked Jul 17, 2023 by avibootz

1 answer 132 views

How to create SQL SELECT query to find all the words from string in database rows with PHP

asked Jan 29, 2021 by avibootz

1 answer 130 views

How to create SQL SELECT query to find all the words from array in database rows with PHP

asked Jan 29, 2021 by avibootz

1 answer 135 views

How to create database with UTF8 character set in MySQL using SQL

asked Nov 30, 2020 by avibootz

1 answer 137 views

How to create database in MySQL using SQL

asked Nov 29, 2020 by avibootz

1 answer 153 views

How to print field (column) from table in MySQL with PHP and SQL

asked Nov 28, 2020 by avibootz

1 answer 151 views

How to use order by with multiple columns in MySQL with SQL

asked Oct 12, 2020 by avibootz

1 answer 166 views

How to order by field length in MySQL with SQL

asked Oct 12, 2020 by avibootz

1 answer 165 views

How to remove duplicate rows in MySQL with SQL

asked Jul 21, 2020 by avibootz

1 answer 196 views

How to ignore error when insert duplicate rows in MySql table with SQL

asked Oct 17, 2019 by avibootz

1 answer 150 views

How to get the total rows from a MySQL table with SQL in PHP & PDO

asked Oct 9, 2019 by avibootz

2 answers 519 views

How to select a range of rows (N1 to N2) from a MySQL table with SQL

asked Oct 9, 2019 by avibootz

3 answers 545 views

How to select the last N rows from a MySQL table with SQL

asked Oct 9, 2019 by avibootz

2 answers 225 views

How to select the first N rows from a MySQL table with SQL

asked Oct 9, 2019 by avibootz

1 answer 167 views

How to get the total rows from a MySQL table with SQL

asked Oct 9, 2019 by avibootz

1 answer 195 views

How to update table column of every row in MySQL with SQL

asked Sep 25, 2019 by avibootz

2 answers 225 views

How to change the database engine of a MySQL database table to MyISAM or InnoDB in SQL

asked Sep 24, 2019 by avibootz

1 answer 163 views

How to get all the columns names from table in MySQL with SQL

asked Sep 22, 2019 by avibootz

1 answer 169 views

How to insert data from one table to another in MySQL with SQL

asked Sep 22, 2019 by avibootz

1 answer 178 views

How to filter select rows by column length in MySQL with SQL

asked Sep 7, 2019 by avibootz

1 answer 228 views

How to order select rows by column length in MySQL with SQL

asked Sep 7, 2019 by avibootz

1 answer 169 views

How to select N random records in MySQL with SQL

asked Sep 7, 2019 by avibootz

2 answers 216 views

How to update MySQL table using SQL

asked Aug 2, 2019 by avibootz

1 answer 176 views

How to find non-ASCII characters in MySQL with SQL

asked Mar 19, 2019 by avibootz

1 answer 180 views

How to select records from the last 24 hours in MySQL using SQL

asked Nov 10, 2018 by avibootz

1 answer 213 views

How to get only the first N characters of a field in MySQL with SQL

asked Sep 11, 2018 by avibootz

1 answer 193 views

How to match a whole word in MySQL with SQL

asked Sep 11, 2018 by avibootz

1 answer 207 views

How to remove rows with duplicate value in MySQL field in SQL

asked Jul 6, 2018 by avibootz

1 answer 225 views

How to count duplicate value in MySQL row field with SQL

asked Jul 6, 2018 by avibootz

1 answer 630 views

How to get last Insert id when using on duplicate key update with PDO MySQL SQL and PHP

asked Jun 12, 2018 by avibootz

1 answer 227 views

How to fetch one column from MySQL table into array using PDO and PHP

asked Jun 3, 2018 by avibootz

1 answer 186 views

How to find duplicate values in MySQL table using SQL

asked May 31, 2018 by avibootz

1 answer 209 views

How to change MySql column position without losing data in SQL

asked May 31, 2018 by avibootz

1 answer 257 views

How to generate 1 letter URLs and INSERT INTO MySQL with PDO in PHP

asked Nov 2, 2016 by avibootz

1 answer 202 views

How delete all rows that have a field with more than N characters in MySQL with SQL

asked Oct 2, 2016 by avibootz

1 answer 197 views

How to get the length (count how many characters) of a field in MySQL with SQL

asked Oct 2, 2016 by avibootz

1 answer 232 views

How to return rows in random order in MySQL with SQL

asked Sep 19, 2016 by avibootz

1 answer 195 views

How to order by two columns in SQL and MySQL

asked Sep 18, 2016 by avibootz

1 answer 263 views

How to use SQL INSERT INTO and UPDATE ON DUPLICATE KEY (to avoid duplicate error) in MySQL with PDO in PHP

asked Sep 13, 2016 by avibootz

1 answer 186 views

How to find all the max values of a field in MySQL table with SQL

asked Sep 11, 2016 by avibootz

2 answers 257 views

How to find the max value of a field in MySQL table with SQL

asked Sep 11, 2016 by avibootz

3 answers 302 views

How to format SQL NOW() Function (current system date and time) in MySQL

asked Oct 14, 2015 by avibootz

1 answer 215 views

How to use SQL NOW() Function (current system date and time) in MySQL

asked Oct 13, 2015 by avibootz

3 answers 257 views

How to use SQL ROUND() Function in MySQL

asked Oct 12, 2015 by avibootz

2 answers 281 views

What is the different between SQL LENGTH() and CHAR_LENGTH() Functions in MySQL

asked Oct 11, 2015 by avibootz

2 answers 224 views

How to use SQL CHAR_LENGTH() Function in MySQL

asked Oct 10, 2015 by avibootz

2 answers 219 views

How to use SQL LENGTH() Function in MySQL

asked Oct 10, 2015 by avibootz

4 answers 358 views

How to use SQL MID() and SUBSTRING() functions in MySQL

asked Oct 9, 2015 by avibootz

1 answer 211 views

How to use SQL LCASE() function in MySQL

asked Oct 8, 2015 by avibootz

Most popular tags