MySQL Help

23,008 topics in this forum

1. IF in mysql WHERE clause

   By BuildMyWeb, July 31, 2016   

   • if in mysql where clause
   • 17 replies
   • 1.9k views
   • 
   • Jacques1
   • August 1, 2016

2. REMOVE WhiteSpace BEFORE Update

   By PriteshP23, August 21, 2013   

   • update
   • sql
   • (and 2 more)

     Tagged with:

     • update
     • sql
     • whitespace
     • php
   • 11 replies
   • 1.9k views
   • 
   • PriteshP23
   • August 22, 2013

3. Calculate ranking change

   By old_blueyes, June 23, 2015
   • 12 replies
   • 1.9k views
   • 
   • old_blueyes
   • June 27, 2015

4. SQL Injection - Stored Procedures

   By SLSCoder, September 21, 2021
   • 12 replies
   • 1.9k views
   • 
   • Strider64
   • October 6, 2021

5. Search age range based on birthdate

   By AshleighCo, June 10, 2014
   • 6 replies
   • 1.9k views
   • 
   • Psycho
   • June 10, 2014

6. Problem with sub query

   By mongoose00318, March 24, 2021
   • 18 replies
   • 1.8k views
   • 
   • mongoose00318
   • March 24, 2021

7. How to select records between 2 dates stored as varchar using prepared statement?

   By angel1987, September 8, 2013
   • 3 replies
   • 1.8k views
   • 
   • angel1987
   • September 8, 2013

8. Select distinct entries only

   By SarahBear, December 7, 2014
   • 6 replies
   • 1.8k views
   • 
   • SarahBear
   • December 7, 2014

9. Using upsert with multiple unique index/columns

   By thenorman138, August 9, 2017   

   • sql
   • mysql
   • (and 2 more)

     Tagged with:

     • sql
     • mysql
     • upsert
     • unique
   • 13 replies
   • 1.8k views
   • 
   • Barand
   • August 10, 2017

10. How to check if table row exists in MYSQL statement

    By galvin, November 24, 2014   

    • mysql
    • 11 replies
    • 1.8k views
    • 
    • kicken
    • December 8, 2014

11. command out of sync / clearing the result set.

    By skygremlin, June 5, 2013
    • 8 replies
    • 1.8k views
    • 
    • skygremlin
    • June 5, 2013

12. MySQL update query to automatically Deduct quantity sold from quantity in the stock table 1 2

    By thara, June 4, 2022   

    • mysql
    • sql
    • 25 replies
    • 1.8k views
    • 
    • thara
    • June 8, 2022

13. Mysql query vs Php function not returning same values

    By huck, July 14, 2014
    • 4 replies
    • 1.8k views
    • 
    • huck
    • July 14, 2014

14. Duplicate entry '1' for key 'PRIMARY'

    By Birdzview, March 25, 2013
    • 4 replies
    • 1.8k views
    • 
    • Birdzview
    • March 25, 2013

15. MySQL / PHP set-up

    By phppup, May 24, 2014
    • 13 replies
    • 1.8k views
    • 
    • Ch0cu3r
    • May 30, 2014

16. select according to particular order

    By peppericious, October 14, 2014   

    • mysql query switch
    • 2 replies
    • 1.8k views
    • 
    • peppericious
    • October 14, 2014

17. If statement comparing value of fetched associative array to value of POST passed variable incorrectly determining order of operation

    By Will_Case, December 2, 2013   

    • php
    • mysqli
    • (and 1 more)

      Tagged with:

      • php
      • mysqli
      • prepared statement
    • 2 replies
    • 1.7k views
    • 
    • Will_Case
    • December 2, 2013

18. INNER JOIN and FULL OUTER JOIN in one query

    By EffakT, February 23, 2014
    • 8 replies
    • 1.7k views
    • 
    • EffakT
    • February 24, 2014

19. cannot insert row in table

    By Pawan_Agarwal, June 23, 2013   

    • php
    • mysql
    • (and 1 more)

      Tagged with:

      • php
      • mysql
      • insert
    • 14 replies
    • 1.7k views
    • 
    • Pawan_Agarwal
    • June 24, 2013

20. Premiership table for competition

    By cliftonbazaar, March 22, 2013
    • 8 replies
    • 1.7k views
    • 
    • cliftonbazaar
    • March 25, 2013

21. LOAD_FILE issue with binary data

    By jazzman1, January 14, 2014
    • 2 replies
    • 1.7k views
    • 
    • jazzman1
    • January 14, 2014

22. SQL help for extracting common details 1 2

    By webdev1, September 2, 2013
    • 32 replies
    • 1.7k views
    • 
    • webdev1
    • September 5, 2013

23. Wildcard SQL

    By arunpatal, October 31, 2013
    • 12 replies
    • 1.7k views
    • 
    • Barand
    • October 31, 2013

24. Sum and join 2 tables

    By Obodo, January 31, 2023
    • 13 replies
    • 1.7k views
    • 
    • Obodo
    • February 3, 2023

25. Similar queries

    By ajoo, September 11, 2016   

    • mysql
    • 12 replies
    • 1.7k views
    • 
    • ajoo
    • September 12, 2016